package com.fsy.its.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fsy.its.entity.PointInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
public interface PointInfoMapper extends BaseMapper<PointInfo> {

    @Select("SELECT * from its_point_info \n" +
            "WHERE building_id=#{buildingId} AND point_number=#{pointNumber}")
    PointInfo getByPointNumber(@Param("buildingId") int buildingId,
                               @Param("pointNumber") String pointNumber);
}
